VHS Tables
ODBC queries can be performed against the VHS HistoricalValues table and VHS HistoricalStats table. See Running ODBC Batch Files for more information.
VHS HistoricalStats Table
The following table lists the fields in the VHS HistoricalStats table.
| EarliestTime |
| EntryCount |
| ExpirationDays |
| LatestTime |
| PointId |
| PointIdLong |
| Service |
| Site |
VHS HistoricalValues Table
The following table lists the fields in the VHS HistoricalValues Table.
|
AlarmPriorityCategory
|
|
AlarmSuppressed
|
|
AnalogPoint
|
|
|
| ConfigBit1 |
| ConfigBit2 |
| ConfigBit3 |
| ConfigBit4 |
| ConfigBit5 |
| ConfigBit6 |
| ConfigBit7 |
| ConfigBit8 |
| ConfigBit9 |
| ConfigBit10 |
| ConfigBit11 |
| ConfigBit12 |
| ConfigBit13 |
| ConfigBit14 |
| ConfigBit15 |
|
|
|
DigitalPoint
|
|
EnumPoint
|
|
ExternalValue
|
|
InitedFlag |
|
PointId
|
|
PointIdLong
|
|
PointScheme
|
|
PointTime
|
|
RecordTime |
|
Service |
|
Site
|
|
StringPoint
|
|
UDC
|
|
Unreliable Flag
|
|
UpdatedFlag
|
|
|
|
UserBit1
|
|
UserBit2
|
|
UserBit3
|
|
UserBit4
|
|
UserBit5
|
|
UserBit6
|
|
UserBit7
|
|
UserBit8
|
|
UserBit9
|
|
UserBit10
|
|
UserBit11
|
|
UserBit12
|
|
UserBit13
|
|
UserBit14
|
|
UserBit15
|
|
UserBit16
|
|
|
|
Value
|
|
VhsValueDeleted
|
|
VhsValueEdited
|
|
